SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_ShowApplyingRecordsStudent]

	(
	@param_applicant_userID NVARCHAR(50)
	)

AS
	/* SET NOCOUNT ON */
	SELECT position,dbo.JOL_Recruitment_ApplyingRecords.id,result
	 FROM dbo.JOL_Recruitment_ApplyingRecords,dbo.JOL_Recruitment_Position
	 WHERE
	 recruit_position=dbo.JOL_Recruitment_Position.id AND applicant_userID=@param_applicant_userID
	 ORDER BY handle_time,dbo.JOL_Recruitment_ApplyingRecords.update_time,dbo.JOL_Recruitment_ApplyingRecords.add_time DESC
	 
	
	RETURN
GO
